SQL::Abstract - Generate SQL from Perl data structures

76 ++

76 ++

This module was inspired by the excellent DBIx::Abstract. However, in using that module I found that what I really wanted to do was generate SQL, but still retain complete control over my statement handles and use the DBI interface. So, I set out to ...

MSTROUT/SQL-Abstract-2.000001 - 23 Jan 2021 07:24:31 UTC - Search in distribution

• SQL::Abstract::Test - Helper function for testing SQL::Abstract
• SQL::Abstract::Tree - Represent SQL as an AST
• SQL::Abstract::Reference - Reference documentation for SQL::Abstract
• 8 more results from SQL-Abstract »

SQL::Abstract::Pg - PostgreSQL features for SQL::Abstract

4 ++

4 ++

SQL::Abstract::Pg extends SQL::Abstract with a few PostgreSQL features used by Mojo::Pg. JSON In many places (as supported by SQL::Abstract) you can use the "-json" unary op to encode JSON from Perl data structures. # "UPDATE some_table SET foo = '[1...

SRI/SQL-Abstract-Pg-1.0 - 20 Feb 2021 16:53:26 UTC - Search in distribution

DBIx::SQL::Abstract - Provides a convenient abstraction layer to a database.

++

++

The intention of this module is to join some methods from the DBI and the SQL::Abstract modules, for a convenient and easy use. To begin, we create an object, but first we must create a hash which contains the database parameters as follows. my %dbcf...

ALECS/DBIx-SQL-Abstract-0.07 - 12 Sep 2005 18:09:31 UTC - Search in distribution

SQL::Abstract::Util - Small collection of utilities for SQL::Abstract::Classic

1 ++

1 ++

RIBASUSHI/SQL-Abstract-Classic-1.91 - 17 Oct 2019 10:29:44 UTC - Search in distribution

• SQL::Abstract::Classic - Generate SQL from Perl data structures

SQL::Abstract::More - extension of SQL::Abstract with more constructs and more flexible API

22 ++

22 ++

This module generates SQL from Perl data structures. It is a subclass of SQL::Abstract::Classic or SQL::Abstract, fully compatible with the parent class, but with many improvements : * methods take arguments as *named parameters* instead of positiona...

DAMI/SQL-Abstract-More-1.43 - 05 Mar 2024 19:04:52 UTC - Search in distribution

SQL::Abstract::mysql - Generate SQL from Perl data structures for MySQL and MariaDB

36 ++

36 ++

SQL::Abstract::mysql extends SQL::Abstract with a few MySQL / MariaDB features used by Mojo::mysql. It was inspired by SQL::Abstract::Pg....

JHTHORSEN/Mojo-mysql-1.27 - 26 Oct 2023 12:00:29 UTC - Search in distribution

• Mojo::mysql - Mojolicious and Async MySQL/MariaDB

SQL::Abstract::Limit - portable LIMIT emulation

3 ++

3 ++

Portability layer for LIMIT emulation. new( case => 'lower', cmp => 'like', logic => 'and', convert => 'upper', limit_dialect => 'Top' ) All settings are optional. limit_dialect Sets the default syntax model to use for emulating a "LIMIT $rows OFFSET...

ASB/SQL-Abstract-Limit-0.143 - 28 Mar 2021 19:25:37 UTC - Search in distribution

CellBIS::SQL::Abstract - SQL Query Generator

2 ++

2 ++

The purpose of this module is to generate SQL Query. General queries has covered "insert", "delete", "update", "select", and select with join - ("select_join"). And the additional query has covered to create table....

YUSRIDEB/CellBIS-SQL-Abstract-1.5 - 08 Apr 2021 21:32:00 UTC - Search in distribution

• CellBIS::SQL::Abstract::Test - A part of Unit Testing
• CellBIS::SQL::Abstract::Test::Table - A part of Unit Testing with contain information of tables
• lib/CellBIS/SQL/Abstract.pm
• 1 more result from CellBIS-SQL-Abstract »

SQL::Abstract::Builder - Builds and executers relational queries

++

++

It gives you a very simple way to define fetch documents (rows and related children) from your relational DB (instead of just rows)....

TRON/SQL-Abstract-Builder-v0.1.1 - 26 Apr 2012 20:19:29 UTC - Search in distribution

SQL::Abstract::Complete - Generate complete SQL from Perl data structures

4 ++

4 ++

This module was inspired by the excellent SQL::Abstract, from which in inherits. However, in trying to use the module, I found that what I really wanted to do was generate complete SELECT statements including joins and group by clauses. So, I set out...

GRYPHON/SQL-Abstract-Complete-1.09 - 28 Mar 2024 19:23:02 UTC - Search in distribution

SQL::Abstract::Prefetch - implement "prefetch" for DBI RDBMS

++

++

This class implements "prefetch" in the style of DBIx::Class. Stages of operation: * Generate a "query spec" that describes what you want back from the database - which fields from which tables, and what relations to join. * Generate SQL (and bind pa...

ETJ/SQL-Abstract-Prefetch-0.003 - 11 Apr 2019 04:11:46 UTC - Search in distribution

SQL::Abstract::FromQuery - Translating an HTTP Query into SQL::Abstract structure

3 ++

3 ++

This module is intended to help building Web applications with complex search forms. It translates user input, as obtained from an HTML form, into a datastructure suitable as a %where clause for the SQL::Abstract module; that module will in turn prod...

DAMI/SQL-Abstract-FromQuery-0.11 - 03 Feb 2021 23:38:47 UTC - Search in distribution

• SQL::Abstract::FromQuery::FR - SQL::Abstract::FromQuery extension for French dates and times
• SQL::Abstract::FromQuery::Oracle - SQL::Abstract::FromQuery extension for Oracle queries
• SQL::Abstract::FromQuery::Contains - SQL::Abstract::FromQuery extension for a 'contains' rule

SQL::Abstract::Plugin::TableAlias - automagical table aliasing

++

++

This module is an extension of the SQL::Abstract::Plugin::ExtraClauses plugin, it's objective is to assist with the aliasing of tables....

LNATION/SQL-Abstract-Plugin-TableAlias-0.04 - 12 Feb 2023 20:03:07 UTC - Search in distribution

SQL::Abstract::Plugin::InsertMulti - add mysql bulk insert supports for SQL::Abstract

5 ++

5 ++

SQL::Abstract::Plugin::InsertMulti is enable bulk insert support for SQL::Abstract. Declare 'use SQL::Abstract::Plugin::InsertMulti;' with 'use SQL::Abstract;', exporting insert_multi() and update_multi() methods to SQL::Abstract namespace from SQL::...

ZIGOROU/SQL-Abstract-Plugin-InsertMulti-0.05 - 05 Nov 2018 06:44:30 UTC - Search in distribution

lib/Query/Abstract/Driver/SQL.pm

++

++

KOORCHIK/Query-Abstract-0.01 - 17 Mar 2015 11:04:46 UTC - Search in distribution

lib/SQL/Abstract/Plugin/InsertReturning.pm

++

++

DEPRECATED. This functionality is now in SQL::Abstract itself. This module just wraps around that. Please, stop using this! Some databases have support for returning data after an insert query, which can help gain performance when doing common operat...

CYCLES/SQL-Abstract-Plugin-InsertReturning-0.05 - 11 Mar 2010 00:06:19 UTC - Search in distribution

DBIx::OO - Database to Perl objects abstraction

++

++

This module has been inspired by the wonderful Class::DBI. It is a database-to-Perl-Objects abstraction layer, allowing you to interact with a database using common Perl syntax. Why another Class::DBI "clone"? 1 I had the feeling that Class::DBI is n...

MISHOO/DBIx-OO-0.0.9 - 26 Nov 2008 10:10:27 UTC - Search in distribution

• DBIx::OO::Tree - manipulate hierarchical data using the "nested sets" model

lib/AutoSQL/DBSQL/ObjectAdaptor/Abstract.pm

++

++

JUGUANG/AutoSQL-0.2 - 25 Mar 2004 12:08:08 UTC - Search in distribution

Class::DBI::Sweet - Making sweet things sweeter

++

++

Class::DBI::Sweet provides convenient count, search, page, and cache functions in a sweet package. It integrates these functions with "Class::DBI" in a convenient and efficient way....

PHRED/Class-DBI-Sweet-0.11 - 26 Jul 2011 03:25:47 UTC - Search in distribution

Class::DBI::Sweet::More - More sweet Class::DBI::Sweet

++

++

Class::DBI::Sweet::More provides OUTER JOIN (and has_many table's search option '-and') to "Class::DBI::Sweet"....

ASAKURA/Class-DBI-Sweet-More-0.01 - 03 May 2006 16:03:50 UTC - Search in distribution